SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


/** Create Tables **/

/* Create stored procedures */
CREATE PROCEDURE dbo.[DnnProduct_CDS_AssetsUpdate]
	@ID int,
	@TemplateID int,
	@ResourceID varchar(128),
	@CategoryID int,
	@Title nvarchar(512),
	@Format nvarchar(32),
	@Creator nvarchar(512),
	@Publisher nvarchar(512),
	@Link nvarchar(1024),
	@LinkType tinyint,
	@DRMType tinyint,
	@PackageStatus tinyint,
	@Packaged bit,
	@MaxDownloads int,
	@FileSize bigint,
	@ModificationDate datetime,
	@Notes ntext,
	@SKU nvarchar(50),
	@ListPrice decimal(18,2),
	@Active bit,
	@Archived bit
AS
BEGIN
	UPDATE [DnnProduct_CDS_Assets]
	SET
		TemplateID = @TemplateID,
		ResourceID = @ResourceID,
		CategoryID = @CategoryID,
		Title = @Title,
		Format = @Format,
		Creator = @Creator,
		Publisher = @Publisher,
		Link = @Link,
		LinkType = @LinkType,
		DRMType = @DRMType,
		PackageStatus = @PackageStatus,
		Packaged = @Packaged,
		MaxDownloads = @MaxDownloads,
		FileSize = @FileSize,
		ModificationDate = @ModificationDate,
		Notes = @Notes,
		SKU = @SKU,
		ListPrice = @ListPrice,
		Active = @Active,
		Archived = @Archived
	WHERE [ID] = @ID
END
GO
